GrapeCity.Xaml.CalcEngine
Evaluate(Object[]) Method


GrapeCity.CalcEngine.Functions Namespace > CalcAddressFunction Class > Evaluate Method : Evaluate(Object[]) Method

The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

Row_num is the row number to use in the cell reference.

Column_num is the column number to use in the cell reference.

[Abs_num] specifies the type of reference to return

[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

Creates a cell address as text, given specified row and column numbers.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object
'Usage
 
Dim instance As CalcAddressFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)
public override object Evaluate( 
   object[] args
)

Parameters

args

The args contains 2 - 5 items: row_num, column_num, [abs_num], [a1], [sheet_text].

Row_num is the row number to use in the cell reference.

Column_num is the column number to use in the cell reference.

[Abs_num] specifies the type of reference to return

[A1] is a logical value that specifies the A1 or R1C1 reference style. If a1 is true or omitted, ADDRESS returns an A1-style reference; if false, ADDRESS returns an R1C1-style reference.

[Sheet_text] is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.

Return Value

A System.Object value that indicates the evaluate result.
See Also

Reference

CalcAddressFunction Class
CalcAddressFunction Members
Overload List